package cn.tedu.mapper;

import cn.tedu.pojo.ApplicationForm;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ApplicationFormMapper extends BaseMapper<ApplicationForm> {
    @Select("select n.novel_title from novel n " +
            "join novel_chapter nc on nc.novel_id = n.id " +
            "join chapter c on c.id = nc.novel_chapter " +
            "where c.id = #{id}")
    String getNovelName(Integer id);
}
